How to: Print charts separately from a worksheet.
Solution:
Select the chart to print. Select 'Page Setup...' from the 'File' menu. Click the 'Chart' tab from the 'Page Setup' dialog box and specify how the chart is to be printed on a separate page in the 'Printed Chart Size' group. Click 'Print...' to print the chart.
1) Double-click on the chart to select it. (A striped border with handles appears around the chart.)
2) Select the 'File' menu and select 'Page Setup...'. (The Page Setup dialog box appears.)
3) Click 'Chart' tab.
4) Select one of the following printing options in the 'Printed Chart Size' group:
a) Select the 'Use Full Page' radio button to enlarge the chart to fill the entire printed page.
NOTE: The chart cannot be moved or sized and may appear unproportional when this option is selected.
b) Select the 'Scale To Fit Page' radio button to enlarge the chart to fit the page size while keeping its proportions.
c) Select the 'Custom' radio button to keep the dimensions of the chart as displayed on the screen.
Selecting the printing option
5) (Optional) To print the chart without headers or footers:
6) Click 'Print...'. (The Print dialog box appears.)
the Print dialog box
NOTE: The 'Selected Chart' radio button is already selected in the 'Print What' group.
7) (Optional) Select the appropriate printer from the 'Name' drop-down list of the 'Printer' group.
8) Click 'OK'.
